Daer all
I do this formula on a row then double click to get this formula applied on the whole rows as follows:
=VLOOKUP(I37,Sheet2!A1:B58,2,0)
=VLOOKUP(I37,Sheet2!A2:B58,2,0)
=VLOOKUP(I37,Sheet2!A3:B58,2,0)
my problem is A lookup table I need this A to be 1 on the every line
any reply or help would be highly appreciated
put a $ infront
make it
$A$1
cell referencing explained
http://www.excel-easy.com/functions/...eferences.html
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
omg perfect thnks
thanks for the rep
suggest you also put the $ on the 2nd part of array so the whole array doesnt shift
ie $A$1:$B$58
Cheers
Hum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks