Excel Formula To Look Up Data

January 24, 2013 at 11:34:10
Specs: Windows 7
I have 2 excel spreadsheets. On sheet 1 it contains data with our ref numbers associated with the client numbers. Is there a way that I can type in our ref number and have it automatically fill in the client ref associated with that ref number?

Thank you

See More: Excel Formula To Look Up Data

Report •

January 24, 2013 at 11:48:07
Sounds like you need a =VLOOKUP()

Look here:

Also, questions concerning MS Office are best asked in the Office Software Forum.



Report •

January 24, 2013 at 12:14:51
The answer to your question depends on the layout of your data. Excel has various "lookup" functions such a VLOOKUP, INDEX, MATCH, etc. Each has its merits and its drawbacks.

If you'll post a short example of your data, we could be more specific. Please click on the following line and read the instructions found via that link before posting your data. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question