Trying to insert the following formula: =vlookup(C2,IMPORTRANGE("LINK","AA!c1:c2978"),6,0) to lookup between to different sheets
but it keeps telling me VLOOKUP evaluates to an out of bounds range.
Both files are attached plz help
Trying to insert the following formula: =vlookup(C2,IMPORTRANGE("LINK","AA!c1:c2978"),6,0) to lookup between to different sheets
but it keeps telling me VLOOKUP evaluates to an out of bounds range.
Both files are attached plz help
docs.google.com/spreadsheets/d/1NaEnJOTaEb5IRGsPB5uZGxNrnhyx6vbH3FHpn5rQwlo/edit#gid=1807590520
docs.google.com/spreadsheets/d/1R-mUNdo_hCX5R50_oTbMQq5rAHNXUVGtCKz7YnuRhOE/edit?usp=sharing
Hi ahmadjw,
What is your expected result for cell C2?
to get the match row from the column number 6
If you want to return the result from col F useFormula:Please Login or Register to view this content.
I wanto to return the result of column I.. i did the following but still not work
=vlookup(C2,IMPORTRANGE("docs.google.com/spreadsheets/d/1NaEnJOTaEb5IRGsPB5uZGxNrnhyx6vbH3FHpn5rQwlo/edit#gid=1807590520","AA!C1:C2978"),6,0)
it keeps telling me VLOOKUP evaluates to an out of bounds range.
In that case it should beFormula:Please Login or Register to view this content.
I beleavie its worked .. thx alot dear for your help .. much appreciated
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks