On the sheet named “STATS”, column A20 thru A31 are numbered 1-12.
In the adjacent column “B20 thru B31” are various names labeled “TYPE”.
I need a formula for the following:
When a number (1-12) is entered on sheet ‘LG’, column D6:D1005,
The “TYPE” name listed in the adjacent column on sheet “STATS” will be entered into sheet ‘LG’, column E6:E1005 based on which number (1-12) was entered.
Thank You
In LG, E6, copied down:
=IF(D6="","",VLOOKUP(D6,STATS!A20:B31,2,FALSE))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Its not working when i try to use further down the page. When I copied the formula down, the A20 thru A31 continues to climb as well so further down those numbers are rising to A29 thru A40, and so on.
Can you adjust the formula so that the A20 thru A31 remain the same as I continue anywhere D6:D1005?
Sorry. Not enough coffee yet... an elementary goof
=IF(D6="","",VLOOKUP(D6,STATS!$A$20:$B$31,2,FALSE))
Thank you, I have alot of work to do to this sheet so I am taking it a little at a time.
Really appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks