Home > Net >  How do I return an entire row from a different excel sheet by looking up a value in a column?
How do I return an entire row from a different excel sheet by looking up a value in a column?

Time:01-25

I feel like I've watched a million Youtube videos and keep getting the "#VALUE!" error. What I need is to have an input cell which I would be entering the phone number for a customer, then have that number found in a spreadsheet and return the entire row for that customer in a row underneath my input. Any ideas?

CodePudding user response:

=XLOOKUP($G$3;$B$2:$B$5;$A$2:$C$5)

enter image description here

CodePudding user response:

=VLOOKUP(Lookup Cell,Lookup Range,First Column,FALSE)
  1. Lookup Cell e.g. $A$1
  2. Lookup Range e.g. $A$1:$G$1
  3. First Column would be COLUMN(A1)

=VLOOKUP($A$1,$A$1:$G$1,COLUMN(A1),FALSE)
  • Related