look up only input values sheet 1 and print sheet 3.

[Bobby1980]

Hi there,

I was wondering if anyone would possibly be able to be kind enough to help me with an issue that I am currently stuck on.

cell a b c d e f g h i j k l m n o p q

1 pt bear mins secs dist east north code

2 repeat for entered lines

3


4


5


sheet 1


was wondering if vlookup would be of use sheet 3, to bring over coordinates and code if bearing mins secs and distance are entered sheet 1.
If not Vlookup would lookup work?
if so would someone be kind enough to please help me out with writing a quick formula to make this possibly work.

Any help would be greatly appreciated,


Warmest Regards,


Rob

 

[oldbrewer]

is sheet 1 the ref sheet and sheet 3 contains the lookup ref

 

[Bobby1980]

is sheet 1 the ref sheet and sheet 3 contains the lookup ref

Hi mate,
Sheet 1 I want to enter the data,

for example

point number bearing minutes seconds code point number east north code

1 90 00 00 cnr 1 1 1000 1000 cnr 1

if I enter in say the above data I would like it to print only the 4 values to the right into sheet 3.
I am only a novice at this so would really be looking for your complete guidance and knowledge.
This would continue for the rows to follow under the starting row.

Thank you for your initial reply look forward to your absolute guidance,


Kind Regards,

Rob

 

[oldbrewer]

point number bearing minutes seconds code point number east north code
1 90 00 00 cnr 1 1 1000 1000 cnr 1
point number	bearing	minutes	seconds	code	point number	east	north	code
1	90	00	00	cnr	1	1000	1000	cnr	1
		is this your data and whaty is the last 1

<colgroup><col><col span="10"></colgroup><tbody>
</tbody>

 

[Bobby1980]

point number bearing minutes seconds code point number east north code
1 90 00 00 cnr 1 1 1000 1000 cnr 1
point number	bearing	minutes	seconds	code	point number	east	north	code
1	90	00	00	cnr	1	1000	1000	cnr	1
		is this your data and whaty is the last 1

<tbody>
</tbody>

B

C

D

E

F

M

N

O

P

Q

R

Deg° <tbody> </tbody>

Min' <tbody> </tbody>

Sec'' <tbody> </tbody>

Horz Dist <tbody> </tbody>

DESCRIPTION <tbody> </tbody>

POINT <tbody> </tbody>

ADJUSTED EAST <tbody> </tbody>

ADJUSTED NORTH <tbody> </tbody>

DESCRIPTION <tbody> </tbody>

ADJ. BEARING & DISTANCE <tbody> </tbody>

FROM~TO <tbody> </tbody>

8

1 <tbody> </tbody>

3200000.000 <tbody> </tbody>

6240000.000 <tbody> </tbody>

CNR1

9

0 <tbody> </tbody>

6 <tbody> </tbody>

50 <tbody> </tbody>

100.000 <tbody> </tbody>

CNR1 <tbody> </tbody>

10

2 <tbody> </tbody>

3200000.182

6240100.001 <tbody> </tbody>

CNR2

0°6'15''~100.000712896085

CNR1~CNR2

11

RPT

12

RPT

13

TO

66

STILL SHEET 1

75

B

C

D

E

F

I

J

K

L

Q

R

76

90 <tbody> </tbody>

0 <tbody> </tbody>

50 <tbody> </tbody>

3 <tbody> </tbody>

GIP-FD <tbody> </tbody>

100 <tbody> </tbody>

3200003.000 <tbody> </tbody>

6239999.999 <tbody> </tbody>

GIP-FD <tbody> </tbody>

270°0'50'' <tbody> </tbody>

GIP-FD _ CNR1 <tbody> </tbody>

77

78

RPT

RPT

RPT

RPT

RPT

TO

106

RPT

RPT

<tbody>
</tbody>

SHEET 3 IS IT AT ALL POSSIBLE TO ARRANGE THEM INTO THIS

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

3200000.000

6240000.000

CNR1

2 <tbody> </tbody>

3200000.182

6240100.001 <tbody> </tbody>

CNR2

0°6'15''~100.000712896085

CNR1~CNR2 <tbody> </tbody>

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 917.6px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

CNR1

<tbody>
</tbody>

 

[oldbrewer]

is 0 6 `15 0 6 50
where does 100.000712896085 come from

 

[Bobby1980]

Hi mate,

Item in column Q in row 10 is a CONCATENATE(V10,$S$6,T10,$T$6,U10,$U$6,$W$6,TEXT(X10,"0.000"),$X$6)

Item in col O in row 76 is a
CONCATENATE(Q76,$S$6,r76,$T$6,S76,$U$^,$W$6,TEXT(Z76,"0.000"),$X$6)

COLUMNS O & P IN ROW 76 WERE Q & R, I HOPE THIS WONT MUCK YOU UP.


Thankyou again,

Rob

 

[oldbrewer]

can we start again - it is not clear what your original data is - nor what you want - if you cannot format it try putting a border on all cells and coloring them yellow, I am sure we can help you once we understand the issue....