BuscarV formula
Hi all, i have a dude, i use BUSCARV(VLOOKUP) function for do this:
A1=456.34
A2=1234.45
A3=111.22
A4=543.23
A5=1900.55
A6=898.67
in C1 i try this formula.
=BUSCARV(B1,A1:A6,A:A,FALSO)
or
=VLOOKUP(B1,A1:A6,A:A,FALSE)
in cell B1 i type this number: 543.23 but not give me the result.... if exist the value or not in the matrix.
What does the A:A do? Usually the formula I'm familiar with is =vlookup(b1,A1:a6,1,false)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Chances are that the value in A4 is not exactly as it appears.
What does the formula =B1=A4 return?
Entia non sunt multiplicanda sine necessitate
Hi friends, with: =vlookup(b1,A1:a6,1,false) i get an #N/A
but: with: =vlookup(B1,A1:A6,1,FALSE) i get the result: 543.23
Solved my problem, thanks...
not sure how that differs from my recommendation nor how the second differs from the first but good! don't forget to mark the post as solved.
Last edited by Sam Capricci; 11-13-2013 at 01:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks