Lookup multiple columns in a single cell and return single value Excel

  Kiến thức lập trình

I have two Sheets ( Sheet 1 and Sheet 2 )

I would like to populate ORDER ID in Sheet 2 using the Asset tag from Sheet 2 and compare
the Asset tag in Sheet 1.

=VLOOKUP(““&B4&”“,’Order Data’!Z:Z:’Order Data’!AA:AA,2,FALSE)

New contributor

yash ballari is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT