Lookup in 3 tables
Closed
Tornado1981
-
Apr 1, 2010 at 02:32 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 1, 2010 at 10:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 1, 2010 at 10:52 PM
Related:
- Lookup in 3 tables
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Five nights in anime 3 - Download - Adult games
- Acer aspire 3 keyboard light - Guide
- Hitman 3 free download - Download - Action and adventure
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 1, 2010 at 10:52 PM
Apr 1, 2010 at 10:52 PM
some clarity is required
column J column k
300 1/1/10----formula is =INDEX($G$2:$G$8,MATCH($J$1+ROW(A1)-1,$H$2:$H$8,0),1)---copy this down for next 2 rows.
2/2/10
#N/A
305 3/3/10---the formula is =INDEX($G$2:$G$8,MATCH($J$5-ROW(A1)+1,$H$2:$H$8,0),1)---copy it down
5/5/10
#N/A
in column H there is no 302 and no 303 and that is why #N/A
there are moe than 301 or 300 in column H which date do youwnat.
if you modify the formlas to suity you it is ok;.
column J column k
300 1/1/10----formula is =INDEX($G$2:$G$8,MATCH($J$1+ROW(A1)-1,$H$2:$H$8,0),1)---copy this down for next 2 rows.
2/2/10
#N/A
305 3/3/10---the formula is =INDEX($G$2:$G$8,MATCH($J$5-ROW(A1)+1,$H$2:$H$8,0),1)---copy it down
5/5/10
#N/A
in column H there is no 302 and no 303 and that is why #N/A
there are moe than 301 or 300 in column H which date do youwnat.
if you modify the formlas to suity you it is ok;.