Is it possible to lookup a single value across multiple columns?
A B C D E F 1 First Name Last Name Invoice # PO # County Price 2 Gerald Ford 1 101 Cook 132 3 Abraham Lincoln 2 102 Lake 25 4 David Stern 3 103 Davis 27 5 Jim Beam 4 104 Geneva 78 6 Rosetta Stone 5 105 Marion 89
The sheet looking up information on the above table looks like this:
A B 1 Data Price 2 Rosetta Lookup Formula(A2) 3 Geneva Lookup Formula(A3) 4 1 Lookup Formula(A4) 5 103 Lookup Formula(A5) 6 Ford Lookup Formula(A6)
Bookmarks