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)
CodePudding user response:
=VLOOKUP(Lookup Cell,Lookup Range,First Column,FALSE)
- Lookup Cell e.g. $A$1
- Lookup Range e.g. $A$1:$G$1
- First Column would be COLUMN(A1)
=VLOOKUP($A$1,$A$1:$G$1,COLUMN(A1),FALSE)