Hi. I am trying to develop a worksheet that searches someone else's XLS to
reconcile data. The other user has data in two differnt columns (to keep
prints to one page and save space).

I am using this formula =INDEX(Working!B:B,MATCH(I2,Working!A:A,0)) to
look for data and match my data to their data for our reports. For example,
if a computer is inventoried in office # 1 and gets moved to office #3, my
report should reflect office #3 as well. However, the computer might be in
column C or it might be listed in column F.

Is there a way to use this formula (or some other) to query different
columns in the same sheet and return to me the location?