Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why doesn't this formula work!?!
=LOOKUP(LEFT(A1,1),NUMS,LETS) Column A contains numbers with multiple digits. NUMS is a list of single digit numbers (Column A in Sheet 2) LETS is a list of letters (Column B in Sheet 2) I want to find the first digit of the number in A1, look it up in NUMS, and return the corresponding value from LETS. This works just fine as =LOOKUP(A1,NUMS,LETS) when A1 refers to a single digit number from the NUMS list. It also works just fine as =LOOKUP(1,NUMS,LETS) and returns the letter that corresponds to the number 1. It returns #N/A when my lookup value uses the left formula. Help? Why doesn't this work? And is there another way to make this happen? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to maintain references when copying lookup formula | Excel Worksheet Functions | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
References And Lookup | Excel Discussion (Misc queries) | |||
How to change lookup references | Excel Worksheet Functions | |||
Lookup in table with two equal references | Excel Discussion (Misc queries) |