jeudi 21 janvier 2021

Nested IF function inside a vlookup for google sheets

I'm trying to nest an IF function inside a vlookup to filter data based on a cell in another sheet.

The ideal functionality would be for the cell to return data if it meets a specific criteria otherwise leave it blank.

This is what I have so far:

=IFERROR(vlookup(E2,IF('internal_all[Paste Here]'!H3="Indexable",'internal_all[Paste Here]'!A:AB,""),28,0))

Currently, it doesn't work but instead I get an error "VLOOKUP equates to an out of bounds range".

Any help would be much appreciated.

Here's a copy of my gsheet: https://docs.google.com/spreadsheets/d/13mcOOHIP6-YQKOhE_LHnmu3-7bSNKzvCSTVZ5BnTxPA/edit#gid=0

Aucun commentaire:

Enregistrer un commentaire