Log In
Register
Home
April 21, 2020
Offline
Hello, how are you? I am sending you this so you can see where I am failing because I get the error # N / A, the function is "search for" and I think that the previous steps do them well, but it does not work, thanks, I send you the image so you can see where there may be the error, I leave the teams in the column that is next to the one in the error, and I want the data corresponding to each team that is the yellow column to appear, well, you already told me, thank you
Trusted Members
December 20, 2019
Offline
https://www.myonlinetraininghu.....this-first
Please add an example workbook so that we can a) see what is going on with the actual data and b) we dont have to waste find recreating the data
VIP
Trusted Members
December 7, 2016
Offline
Hello,
As Purfleet writes, please add a workbook instead of picture. The only reason why you get #N/A as a result of your VLOOKUP formula is because it can't find an exact match.
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
If range_lookup is TRUE, then if the value in the lookup_value is smaller than the smallest value in the first column of the table_array, you'll get the #N/A error value.
If range_lookup is FALSE, the #N/A error value indicates that the exact number isn't found.
This link gets you to an Office Support page (in Spanish) guiding how to correct this error in your data.
Br,
Anders
April 21, 2020
Offline
Hello, I could already detect the error, a colleague was looking and discovered that it was a space, I had separated the columns of a party, Valencia - Barcelona, for example, with the script - and of course there was always the There is space until I reach that script, I already corrected it, thank you very much for your answers, you have been very kind. Thank you.
1 Guest(s)
