• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

excel question...

A

Al Neri

Diamond Member
if i have a spreadsheet of

__a_b_
1 | a | 1 |
2 | b | 2 |
3 | c | 3 |
4 | d | 4 |
5 | e | 5 |

how could i make off to the side if i put "d" in a cell off to the right like E4 ... it give me the corresponding number (in this case, 4)
 
geez...tough room

here...put this in a cell that you want the answer ...it looks up the value in E4, in the lookup table a1:b5, returns the value in the 2nd column of that table.

=VLOOKUP(E4,A1:B5,2,FALSE)

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top