Hello,
The Problem: using Vlookup formula (* =VLOOKUP(A5,$A$1:$A$9,2,FALSE)), I cannot get column results to work in A5 or A6 (as shown below - just #N/A or REF!). Eventually, I managed to get A2 match values to display (by moving Column A2 to A1). What was blocking the result?
$List$ Match Type(t) Score t1 total t2 total
A1 A2 A3 A4 A5 A6
1 3 5 jobs #N/A #N/A
2 4 t1 0 jobs 0 jobs #N/A
4 5 t2 25 jobs #N/A 25 jobs
5 6 0 jobs #N/A #N/A
7 7 t2 5 jobs #N/A 5 jobs
8 8 t1 14 jobs 14 jobs #N/A
9 9 t2 70 jobs #N/A 70 jobs
-------------------------------------------------------------
14 jobs 100 jobs
Actually, I created a workaround using =VLOOKUP(A4,$B$4:$B$279,1,FALSE), but I had to change the layout of the table (by moving the A2 column to A1).
Configuration: Windows Vista Firefox 3.5.3
Little confusing. your column heading A5 is like to be confused with cell A5(5th row 1st column ).
|
10.5.7 change main display Acer aspire can't get second monitor display Change display on laptop to connect to tv Change display on laptop to connect to tv hdmi Change display sys properties of ram Change video connection display without connecting on vista Changing skin display on xp sp3 Display color change to 256 after restart Do you have to restart your laptop to get a display monitor to work Excel get value from closed vlookup Get external display to show the same as mac How to change external monitor and display settings on an acer laptop How to change volume display on windows vista How to change your display on windows 7 How to get all the change out of a phone box How to get my laptop vaio to display on my tv How to get your 2g changed from apple How to get your display back on your computer after you have disabled it