One comment on “Google Sheets: Searching for data on one sheet and pull the searched data from another sheet either locally or from another sheet.

  1. =iferror(VLOOKUP(B2,Sheet1!C:E,3,false))

    Should use this instead which will search the entire column of C to E instead of just the one row as in:

    =IFERROR(VLOOKUP(B3,Sheet2!C3:E3,3,false))

    This will be searching for whatever your searching for as specified from B3 on Row 3, Column C to E.. whereas the above one will search all rows on column C to E.

Leave a Reply to Frankie Cancel reply

Your email address will not be published. Required fields are marked *