Hello!... Im having issues making a Vlookup function to do the following in this image. What I need is to search in Column E for any hit in column A and then write in Column C the corresponding FOLIO of COlumn F, if there is any value found. For example. If the value 302.735 is found in Column E. It should write in cell C2 the value 18759, which corresponds to its FOLIO of that value, if nothing is found, on that cell there should be a N/A or something. THanks for the help
Capture.PNG
Welcome to the forum.
Try this:
=VLOOKUP(A2,$£$2:$F$500,2,0)
If that doesn't work, then there are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
For some reason it doesn't works, it gives me an error. Excel says there is a problem with the formula
Last edited by AliGW; 05-09-2022 at 04:24 PM. Reason: PLEASE don't quote unnecessarily
Try this:
=VLOOKUP(A2,$E$2:$F$500,2,0)
or this:
=VLOOKUP(A2;$E$2:$F$500;2;0)
Thank! It works!... but I fail to get it why it works lol. =VLOOKUP(lookup_value;table_array;col_index_num;[range_lookup]).... So col_index_num is 2 and [range_lookup] is 0.. but what those means?
Last edited by AliGW; 05-10-2022 at 12:35 AM. Reason: PLEASE don't quote unnecessarily
Wrong!
=VLOOKUP(lookup_value;table_array;col_index_num;lookup_type)
Type 0 or FALSE gives an exact match.
https://support.microsoft.com/en-us/...8-93a18ad188a1
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks