Acknowledge col AH

Status
Not open for further replies.

Sunline

Well-known Member
Joined
Oct 6, 2007
Messages
701
Office Version
  1. 2016
Platform
  1. Windows
Im trying to get the same results I have in cols BJ and BK .

The function needs to acknowledge col AH somehow .

Thanks .
Excel Workbook
AHALAOBIBJBKBLBM
1HorseNameFinishingpositionDecimalmarginXupPlMgAB
2Bahhare Babe119.21  
3Bahhare Babe231119.2119.2
4Bahhare Babe96.712323
5Bahhare Babe41.32  
6Bahhare Babe1210.33  
7Bahhare Babe1310.2196.796.7
8Bahhare Babe51.4241.341.3
9Bahhare BabeFF11310.21310.2
10Sarbara Ann20.51FF
11Sarbara Ann10.4251.4
12Sarbara Ann36.231210.3
13Sarbara Ann82.4120.520.5
14Sarbara Ann42.6210.410.4
15Sarbara Ann41.9182.482.4
16Sarbara Ann51.8141.941.9
17Sarbara AnnRORO242.642.6
18Sarbara Ann10.1336.236.2
19Farbaric1017151.8
20Farbaric13.8110171017
21Farbaric20.52RORO
22Farbaric20.3310.1
23Farbaric61.74  
24Farbaric11.7113.813.8
25Farbaric44.1220.520.5
26Farbaric10.1320.320.3
Sheet1
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sunline: You have been told before not to create duplicate threads. This is the third thread you have created on this topic. keep it up and disciplinary action may be taken. Closed.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,912
Messages
6,175,340
Members
452,638
Latest member
Oluwabukunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top