VLOOKUP help

[bmanager]

I need a formula to do the following:

After entering a numerical code on sheet1 column B, automatically look at a list on sheet 4 column D to see if it already exists.

If it does exist, copy the corresponding code 'value' to columns C on sheet1.
If it does not exist, return a value FALSE.

I tried a VLOOKUP function however I get a circular reference warning
=VLOOKUP(B5,Ledger!B:D,2,FALSE)

I have a copy of the workbook on Google Drive:
https://drive.google.com/file/d/0B1E...ew?usp=sharing

...and an image of the
https://drive.google.com/open?id=0B1...0pzWHJKbUF4Vjg


Please note that I did not write the posted Excel worksheet and I'm trying to modify it so that it works better with my workflow.
I'd like to know how to fix this but also know why my above logic is so wrong :-/.

Thanks!
Cindy

[JBeaucaire]

Your sheet 4 is called "Raw Lists", so I would think your VLOOKUP should be matching to there.

=VLOOKUP(B5, 'Raw Lists'!B:D, 2, FALSE)

[southward]

Hi bmanager,

Your circular reference warning is due to you trying to pull data from the same spot that you want your data to be shown.

Change "Ledger!" to "Raw List!"

Use this formula in C5:

Please Login or Register  to view this content.

Hope this is helpful.

Cheers

[bmanager]

Thank you. This makes sense.

[bmanager]

Thank you. This worked perfectly...appreciate your help very much! :-)

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.